NSQL Functions overview

It is possible to modify the contents of a column used in the WHERE clause to further enhance the query that is being performed by using intrinsic functions. Consider a table with a surname field in which the surnames are of mixed case, so that Smith could appear as Smith, SMITH or smith etc. By applying the function UCASE (upper case), we can convert all the records for the Surname column to upper case before performing the query.

For example, the statement below forms a Domain that contains the various forms of Smith:

• Database Reference Guide Overview
• Getting Started
• Introduction to Engine Concepts
• Working with Engine
• NSQL Reference
• NSQL Basics
• NSQL Functions Overview
  • NSQL Functions A to Z
  • NSQL Intrinsic Functions
  • DATE Columns
  • Distance Calculations
  • Miscellaneous Functions
  • NUMERIC Columns
  • Text Columns
  • TIME Columns
• NSQL Expressions Overview
• Using NSQL